Adding Census Bureau key to repository

## 
## Attaching package: 'censusapi'
## The following object is masked from 'package:methods':
## 
##     getFunction
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
## -- Attaching packages ----------------------------------------------------------------------- tidyverse 1.2.1 --
## v ggplot2 3.1.0     v readr   1.1.1
## v tibble  1.4.2     v purrr   0.2.5
## v tidyr   0.8.2     v stringr 1.3.1
## v ggplot2 3.1.0     v forcats 0.3.0
## -- Conflicts -------------------------------------------------------------------------- tidyverse_conflicts() --
## x dplyr::filter() masks stats::filter()
## x dplyr::lag()    masks stats::lag()
## Loading required package: sp
## rgdal: version: 1.3-6, (SVN revision 773)
##  Geospatial Data Abstraction Library extensions to R successfully loaded
##  Loaded GDAL runtime: GDAL 2.2.3, released 2017/11/20
##  Path to GDAL shared files: C:/Program Files/R/R-3.5.1/library/rgdal/gdal
##  GDAL binary built with GEOS: TRUE 
##  Loaded PROJ.4 runtime: Rel. 4.9.3, 15 August 2016, [PJ_VERSION: 493]
##  Path to PROJ.4 shared files: C:/Program Files/R/R-3.5.1/library/rgdal/proj
##  Linking to sp version: 1.3-1
## -------------------------------------------------------------------------
## You have loaded plyr after dplyr - this is likely to cause problems.
## If you need functions from both plyr and dplyr, please load plyr first, then dplyr:
## library(plyr); library(dplyr)
## -------------------------------------------------------------------------
## 
## Attaching package: 'plyr'
## The following object is masked from 'package:purrr':
## 
##     compact
## The following objects are masked from 'package:dplyr':
## 
##     arrange, count, desc, failwith, id, mutate, rename, summarise,
##     summarize
## 
## Attaching package: 'plotly'
## The following objects are masked from 'package:plyr':
## 
##     arrange, mutate, rename, summarise
## The following object is masked from 'package:ggplot2':
## 
##     last_plot
## The following object is masked from 'package:stats':
## 
##     filter
## The following object is masked from 'package:graphics':
## 
##     layout
## 
## Attaching package: 'olsrr'
## The following object is masked from 'package:datasets':
## 
##     rivers
## 
## Attaching package: 'maps'
## The following object is masked from 'package:plyr':
## 
##     ozone
## The following object is masked from 'package:purrr':
## 
##     map

Loading datasets for Migration from 2010 to 2016

## Warning in responseFormat(raw): NAs introduced by coercion

## Warning in responseFormat(raw): NAs introduced by coercion

## Warning in responseFormat(raw): NAs introduced by coercion

## Warning in responseFormat(raw): NAs introduced by coercion

## Warning in responseFormat(raw): NAs introduced by coercion

Cleaning the Immigrant dataset and trend

Importing data for crime

Variable declaration and calculation of Immigrant data

## Adding missing grouping variables: `district`

Functions for operations for immigrant data

Functions for operations for crime data

Plotting Immigrant trend year wise from 2010 to 2016

## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## No scatter mode specifed:
##   Setting the mode to markers
##   Read more about this attribute -> https://plot.ly/r/reference/#scatter-mode
## No scatter mode specifed:
##   Setting the mode to markers
##   Read more about this attribute -> https://plot.ly/r/reference/#scatter-mode
## A marker object has been specified, but markers is not in the mode
## Adding markers to the mode...
## Warning in verify_mode(p): A textfont object has been specified, but text is not in the mode
## Adding text to the mode...
## A line object has been specified, but lines is not in the mode
## Adding lines to the mode...
## Warning in verify_mode(p): A textfont object has been specified, but text is not in the mode
## Adding text to the mode...
## A line object has been specified, but lines is not in the mode
## Adding lines to the mode...
## Warning in verify_mode(p): A textfont object has been specified, but text is not in the mode
## Adding text to the mode...

##plotting immigrant trend council district wise

## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`

statastical analysis

## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## OGR data source with driver: ESRI Shapefile 
## Source: "C:\Users\Deadpool\Documents\R\Project 15\Datasets\ShapeFile\CnclDist_July2012.shp", layer: "CnclDist_July2012"
## with 15 features
## It has 10 fields

Saving data to file for mapping

## 
## Attaching package: 'qdapTools'
## The following object is masked from 'package:plyr':
## 
##     id
## The following object is masked from 'package:dplyr':
## 
##     id
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`

Further Analysis on Crime Rate

## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`

regression analysis

## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## 
## Call:
## lm(formula = freq ~ race_abroad_hispanic, data = regression_hispanic_abroad)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -18.994  -8.413  -1.553   4.860  32.727 
## 
## Coefficients:
##                       Estimate Std. Error t value Pr(>|t|)    
## (Intercept)          46.075337   2.844207  16.200  < 2e-16 ***
## race_abroad_hispanic  0.013652   0.004469   3.055  0.00288 ** 
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 11.55 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.08459,    Adjusted R-squared:  0.07552 
## F-statistic: 9.333 on 1 and 101 DF,  p-value: 0.002879
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## 
## Call:
## lm(formula = freq ~ . - X1 - district, data = regression_hispanic_state)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -18.951  -8.862  -2.871   5.294  30.349 
## 
## Coefficients:
##                      Estimate Std. Error t value Pr(>|t|)    
## (Intercept)         55.501772   3.517717  15.778   <2e-16 ***
## race_state_hispanic -0.002857   0.006465  -0.442     0.66    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 12.06 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.001929,   Adjusted R-squared:  -0.007953 
## F-statistic: 0.1952 on 1 and 101 DF,  p-value: 0.6596
## 
## Call:
## lm(formula = freq ~ total, data = regression_hispanic)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -15.810  -8.410  -3.612   4.586  33.511 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept) 45.905437   4.084199  11.240   <2e-16 ***
## total        0.007425   0.003574   2.078   0.0403 *  
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 11.82 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.04099,    Adjusted R-squared:  0.03149 
## F-statistic: 4.317 on 1 and 101 DF,  p-value: 0.04028
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## 
## Call:
## lm(formula = freq ~ . - X1 - district, data = regression_asian_abroad)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -21.246  -7.091  -2.142   6.439  29.180 
## 
## Coefficients:
##                    Estimate Std. Error t value Pr(>|t|)    
## (Intercept)       58.422243   2.089194  27.964   <2e-16 ***
## race_abroad_asian -0.006095   0.002422  -2.516   0.0134 *  
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 11.71 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.059,  Adjusted R-squared:  0.04968 
## F-statistic: 6.332 on 1 and 101 DF,  p-value: 0.01343
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## 
## Call:
## lm(formula = freq ~ . - X1 - district, data = regression_black_abroad)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -23.712  -6.761  -1.601   5.803  31.808 
## 
## Coefficients:
##                   Estimate Std. Error t value Pr(>|t|)    
## (Intercept)       47.92804    1.67189   28.67  < 2e-16 ***
## race_abroad_black  0.07771    0.01629    4.77 6.22e-06 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 10.9 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.1838, Adjusted R-squared:  0.1758 
## F-statistic: 22.75 on 1 and 101 DF,  p-value: 6.223e-06
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## 
## Call:
## lm(formula = freq ~ . - X1 - district, data = regression_white_abroad)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -22.659  -6.135  -1.345   5.556  26.934 
## 
## Coefficients:
##                    Estimate Std. Error t value Pr(>|t|)    
## (Intercept)       61.314135   1.919703  31.939  < 2e-16 ***
## race_abroad_white -0.008376   0.001826  -4.587 1.29e-05 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 10.98 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.1724, Adjusted R-squared:  0.1642 
## F-statistic: 21.04 on 1 and 101 DF,  p-value: 1.292e-05
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## 
## Call:
## lm(formula = freq ~ . - X1 - district, data = regression_high_abroad)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -19.881  -8.537  -1.084   7.008  28.266 
## 
## Coefficients:
##                       Estimate Std. Error t value Pr(>|t|)    
## (Intercept)           61.68162    2.89522  21.305  < 2e-16 ***
## education_abroad_high -0.04266    0.01485  -2.873  0.00495 ** 
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 11.6 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.07556,    Adjusted R-squared:  0.06641 
## F-statistic: 8.256 on 1 and 101 DF,  p-value: 0.004952
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## 
## Call:
## lm(formula = freq ~ . - X1 - district, data = regression_college_abroad)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -20.790  -8.713  -1.260   7.175  29.213 
## 
## Coefficients:
##                          Estimate Std. Error t value Pr(>|t|)    
## (Intercept)              57.83204    2.32271   24.90   <2e-16 ***
## education_abroad_college -0.01894    0.01002   -1.89   0.0617 .  
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 11.86 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.03415,    Adjusted R-squared:  0.02458 
## F-statistic: 3.571 on 1 and 101 DF,  p-value: 0.06167
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## 
## Call:
## lm(formula = freq ~ . - X1 - district, data = regression_high_abroad)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -19.881  -8.537  -1.084   7.008  28.266 
## 
## Coefficients:
##                       Estimate Std. Error t value Pr(>|t|)    
## (Intercept)           61.68162    2.89522  21.305  < 2e-16 ***
## education_abroad_high -0.04266    0.01485  -2.873  0.00495 ** 
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 11.6 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.07556,    Adjusted R-squared:  0.06641 
## F-statistic: 8.256 on 1 and 101 DF,  p-value: 0.004952
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## 
## Call:
## lm(formula = freq ~ . - X1 - district, data = regression_graduate_abroad)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -21.291  -6.698  -1.054   4.994  28.272 
## 
## Coefficients:
##                            Estimate Std. Error t value Pr(>|t|)    
## (Intercept)               57.752588   1.526007  37.846  < 2e-16 ***
## education_abroad_graduate -0.017077   0.004766  -3.583 0.000525 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 11.37 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.1128, Adjusted R-squared:  0.104 
## F-statistic: 12.84 on 1 and 101 DF,  p-value: 0.0005246
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## 
## Call:
## lm(formula = freq ~ . - X1 - district, data = regression_poverty100_abroad)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -19.635  -8.448  -2.861   5.798  30.556 
## 
## Coefficients:
##                          Estimate Std. Error t value Pr(>|t|)    
## (Intercept)             56.362889   2.594295  21.726   <2e-16 ***
## poverty_abroad_below100 -0.003046   0.003026  -1.007    0.317    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 12.01 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.009933,   Adjusted R-squared:  0.0001299 
## F-statistic: 1.013 on 1 and 101 DF,  p-value: 0.3165
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## 
## Call:
## lm(formula = freq ~ . - X1 - district, data = regression_poverty149_abroad)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -18.242  -8.371  -3.134   5.414  30.544 
## 
## Coefficients:
##                         Estimate Std. Error t value Pr(>|t|)    
## (Intercept)             51.19314    2.84583  17.989   <2e-16 ***
## poverty_abroad_100to149  0.01459    0.01327   1.099    0.274    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 12 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.01182,    Adjusted R-squared:  0.002038 
## F-statistic: 1.208 on 1 and 101 DF,  p-value: 0.2743
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## 
## Call:
## lm(formula = freq ~ . - X1 - district, data = regression_poverty150_abroad)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -23.859  -6.613  -0.814   6.354  26.436 
## 
## Coefficients:
##                          Estimate Std. Error t value Pr(>|t|)    
## (Intercept)             62.481973   2.126890  29.377  < 2e-16 ***
## poverty_abroad_above150 -0.008801   0.001910  -4.609 1.18e-05 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 10.97 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.1738, Adjusted R-squared:  0.1656 
## F-statistic: 21.24 on 1 and 101 DF,  p-value: 1.185e-05
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## Adding missing grouping variables: `district`
## 
## Call:
## lm(formula = freq ~ . - X1 - district, data = regression_population_abroad)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -22.743  -6.692  -1.715   5.703  28.240 
## 
## Coefficients:
##                 Estimate Std. Error t value Pr(>|t|)    
## (Intercept)    61.108968   2.610558   23.41   <2e-16 ***
## S0701_C05_001E -0.003474   0.001154   -3.01   0.0033 ** 
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 11.56 on 101 degrees of freedom
##   (2 observations deleted due to missingness)
## Multiple R-squared:  0.08231,    Adjusted R-squared:  0.07323 
## F-statistic:  9.06 on 1 and 101 DF,  p-value: 0.0033